package com.hnhs.mapper;

import com.hnhs.model.Product;
import com.hnhs.model.ProductInfo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ProductMapper {


    @Select("SELECT name, COUNT(*) as count\n" +
            "FROM 202_product\n" +
            "GROUP BY name;\n")
    List <ProductInfo> getAllProducts();

}
